SELECT DISTINCT p.name, p.id, i.base_filename, p.sale_price_inc_vat, pc.category FROM products p, images i, product_category pc WHERE pc.product = p.id && pc.category IN (85<br />) && p.primary_image = i.id GROUP BY p.name ORDER BY p.creation_date DESC LIMIT 5